Tabela ArchiveDocOrder

Definicja tabeli ArchiveDocOrder

Name

ArchiveDocOrder

Code

ArchiveDocOrder

Comment

 


Lista kolumn tabeli ArchiveDocOrder

Name

Code

ArchiveDocOrderID

ArchiveDocOrderID

ArchiveDocOrderPriorityID

ArchiveDocOrderPriorityID

OrderingSubjectTypeID

OrderingSubjectTypeID

PersonID

PersonID

InstitutionTypeID

InstitutionTypeID

ReservationID

ReservationID

EpisodeID

EpisodeID

EventID

EventID

OrderDT

OrderDT

OrderUser

OrderUser

OrderComments

OrderComments

Name

Name

FirstName

FirstName

LastName

LastName

AddressText

AddressText

OrderForDT

OrderForDT


Kolumna ArchiveDocOrderID tabeli ArchiveDocOrder

Definicja kolumny ArchiveDocOrderID tabeli ArchiveDocOrder

Name

ArchiveDocOrderID

Code

ArchiveDocOrderID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ArchiveDocOrderPriorityID tabeli ArchiveDocOrder

Definicja kolumny ArchiveDocOrderPriorityID tabeli ArchiveDocOrder

Name

ArchiveDocOrderPriorityID

Code

ArchiveDocOrderPriorityID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderingSubjectTypeID tabeli ArchiveDocOrder

Definicja kolumny OrderingSubjectTypeID tabeli ArchiveDocOrder

Name

OrderingSubjectTypeID

Code

OrderingSubjectTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli ArchiveDocOrder

Definicja kolumny PersonID tabeli ArchiveDocOrder

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InstitutionTypeID tabeli ArchiveDocOrder

Definicja kolumny InstitutionTypeID tabeli ArchiveDocOrder

Name

InstitutionTypeID

Code

InstitutionTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ReservationID tabeli ArchiveDocOrder

Definicja kolumny ReservationID tabeli ArchiveDocOrder

Name

ReservationID

Code

ReservationID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie zamówienia z rezerwacja


Kolumna EpisodeID tabeli ArchiveDocOrder

Definicja kolumny EpisodeID tabeli ArchiveDocOrder

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie zamówienia z hospitalizacja


Kolumna EventID tabeli ArchiveDocOrder

Definicja kolumny EventID tabeli ArchiveDocOrder

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

Powiazanie zamówienia z wizyta


Kolumna OrderDT tabeli ArchiveDocOrder

Definicja kolumny OrderDT tabeli ArchiveDocOrder

Name

OrderDT

Code

OrderDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrderUser tabeli ArchiveDocOrder

Definicja kolumny OrderUser tabeli ArchiveDocOrder

Name

OrderUser

Code

OrderUser

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OrderComments tabeli ArchiveDocOrder

Definicja kolumny OrderComments tabeli ArchiveDocOrder

Name

OrderComments

Code

OrderComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Name tabeli ArchiveDocOrder

Definicja kolumny Name tabeli ArchiveDocOrder

Name

Name

Code

Name

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna FirstName tabeli ArchiveDocOrder

Definicja kolumny FirstName tabeli ArchiveDocOrder

Name

FirstName

Code

FirstName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna LastName tabeli ArchiveDocOrder

Definicja kolumny LastName tabeli ArchiveDocOrder

Name

LastName

Code

LastName

Data Type

VARCHAR2(60)

Mandatory

No

Comment

 


Kolumna AddressText tabeli ArchiveDocOrder

Definicja kolumny AddressText tabeli ArchiveDocOrder

Name

AddressText

Code

AddressText

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Adres firmy


Kolumna OrderForDT tabeli ArchiveDocOrder

Definicja kolumny OrderForDT tabeli ArchiveDocOrder

Name

OrderForDT

Code

OrderForDT

Data Type

DATE

Mandatory

No

Comment

Zamówienie dokumentacji na okreslony czas


Lista kluczy tabeli ArchiveDocOrder

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ArchiveDocOrder

Definicja klucza Identifier_1 tabeli ArchiveDocOrder

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment